Overview

Brought to you by YData

Dataset statistics

Number of variables	23
Number of observations	21210
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.6 MiB
Average record size in memory	180.0 B

Variable types

Numeric	18
DateTime	1
Categorical	4

Alerts

`price` is highly overall correlated with `grade` and 3 other fields	High correlation
`bedrooms` is highly overall correlated with `bathrooms` and 2 other fields	High correlation
`bathrooms` is highly overall correlated with `age` and 7 other fields	High correlation
`sqft_living` is highly overall correlated with `bathrooms` and 5 other fields	High correlation
`sqft_lot` is highly overall correlated with `sqft_lot15`	High correlation
`floors` is highly overall correlated with `age` and 3 other fields	High correlation
`grade` is highly overall correlated with `age` and 6 other fields	High correlation
`sqft_above` is highly overall correlated with `bathrooms` and 6 other fields	High correlation
`yr_built` is highly overall correlated with `age` and 3 other fields	High correlation
`zipcode` is highly overall correlated with `long`	High correlation
`long` is highly overall correlated with `zipcode`	High correlation
`sqft_living15` is highly overall correlated with `bathrooms` and 4 other fields	High correlation
`sqft_lot15` is highly overall correlated with `sqft_lot`	High correlation
`age` is highly overall correlated with `bathrooms` and 3 other fields	High correlation
`condition` is highly overall correlated with `yr_built` and 1 other fields	High correlation
`sqft_basement` is highly overall correlated with `sqft_living`	High correlation
`lat` is highly overall correlated with `price` and 1 other fields	High correlation
`waterfront` is highly imbalanced (96.6%)	Imbalance
`view` is highly imbalanced (74.0%)	Imbalance
`id` has unique values	Unique
`sqft_basement` has 12955 (61.1%) zeros	Zeros
`yr_renovated` has 20369 (96.0%) zeros	Zeros
`age` has 530 (2.5%) zeros	Zeros

Reproduction

Analysis started	2024-11-29 08:29:16.949004
Analysis finished	2024-11-29 08:29:33.626008
Duration	16.68 seconds
Software version	ydata-profiling vv4.12.0
Download configuration	config.json

id
Real number (ℝ)

Unique

Distinct	21210
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.5876091 × 10⁹

Minimum	1000102
Maximum	9.9000002 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	165.8 KiB

Quantile statistics

Minimum	1000102
5-th percentile	5.1000251 × 10⁸
Q1	2.1250591 × 10⁹
median	3.9050004 × 10⁹
Q3	7.3124001 × 10⁹
95-th percentile	9.2973011 × 10⁹
Maximum	9.9000002 × 10⁹
Range	9.8990001 × 10⁹
Interquartile range (IQR)	5.187341 × 10⁹

Descriptive statistics

Standard deviation	2.8763082 × 10⁹
Coefficient of variation (CV)	0.62697326
Kurtosis	-1.262218
Mean	4.5876091 × 10⁹
Median Absolute Deviation (MAD)	2.4066965 × 10⁹
Skewness	0.23959282
Sum	9.7303189 × 10¹³
Variance	8.273149 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7129300520	1	< 0.1%
2064800610	1	< 0.1%
3213200180	1	< 0.1%
1545807920	1	< 0.1%
7524950730	1	< 0.1%
2592220040	1	< 0.1%
6852700477	1	< 0.1%
3630160610	1	< 0.1%
1504800097	1	< 0.1%
8687800065	1	< 0.1%
Other values (21200)	21200	> 99.9%

Value	Count	Frequency (%)
1000102	1	< 0.1%
1200019	1	< 0.1%
1200021	1	< 0.1%
2800031	1	< 0.1%
3600057	1	< 0.1%
3600072	1	< 0.1%
3800008	1	< 0.1%
5200087	1	< 0.1%
6200017	1	< 0.1%
7200080	1	< 0.1%

Value	Count	Frequency (%)
9900000190	1	< 0.1%
9895000040	1	< 0.1%
9842300540	1	< 0.1%
9842300485	1	< 0.1%
9842300095	1	< 0.1%
9842300036	1	< 0.1%
9839301165	1	< 0.1%
9839301060	1	< 0.1%
9839301055	1	< 0.1%
9839300875	1	< 0.1%

date
Date

Distinct	372
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	165.8 KiB

Minimum	2014-05-02 00:00:00
Maximum	2015-05-27 00:00:00

Histogram with fixed size bins (bins=50)

price
Real number (ℝ)

High correlation

Distinct	3919
Distinct (%)	18.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	526238.97

Minimum	75000
Maximum	4489000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	165.8 KiB

Quantile statistics

Minimum	75000
5-th percentile	212633.55
Q1	322000
median	450000
Q3	637500
95-th percentile	1085775
Maximum	4489000
Range	4414000
Interquartile range (IQR)	315500

Descriptive statistics

Standard deviation	313627.9
Coefficient of variation (CV)	0.59598
Kurtosis	12.334217
Mean	526238.97
Median Absolute Deviation (MAD)	150000
Skewness	2.6013355
Sum	1.1161529 × 10¹⁰
Variance	9.8362462 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
450000	171	0.8%
350000	167	0.8%
550000	157	0.7%
500000	151	0.7%
425000	148	0.7%
325000	146	0.7%
400000	143	0.7%
375000	137	0.6%
300000	131	0.6%
525000	128	0.6%
Other values (3909)	19731	93.0%

Value	Count	Frequency (%)
75000	1	< 0.1%
78000	1	< 0.1%
80000	1	< 0.1%
81000	1	< 0.1%
82500	1	< 0.1%
83000	1	< 0.1%
84000	1	< 0.1%
85000	1	< 0.1%
89000	1	< 0.1%
89950	1	< 0.1%

Value	Count	Frequency (%)
4489000	1	< 0.1%
4000000	1	< 0.1%
3710000	1	< 0.1%
3650000	1	< 0.1%
3635000	1	< 0.1%
3418800	1	< 0.1%
3400000	1	< 0.1%
3204000	1	< 0.1%
3200000	1	< 0.1%
3100000	1	< 0.1%

bedrooms
Real number (ℝ)

High correlation

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.3589816

Minimum	0
Maximum	8
Zeros	13
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	165.8 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	3
median	3
Q3	4
95-th percentile	5
Maximum	8
Range	8
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.88923322
Coefficient of variation (CV)	0.26473298
Kurtosis	0.95191765
Mean	3.3589816
Median Absolute Deviation (MAD)	1
Skewness	0.37149875
Sum	71244
Variance	0.79073573
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
3	9691	45.7%
4	6778	32.0%
2	2722	12.8%
5	1528	7.2%
6	243	1.1%
1	190	0.9%
7	33	0.2%
0	13	0.1%
8	12	0.1%

Value	Count	Frequency (%)
0	13	0.1%
1	190	0.9%
2	2722	12.8%
3	9691	45.7%
4	6778	32.0%
5	1528	7.2%
6	243	1.1%
7	33	0.2%
8	12	0.1%

Value	Count	Frequency (%)
8	12	0.1%
7	33	0.2%
6	243	1.1%
5	1528	7.2%
4	6778	32.0%
3	9691	45.7%
2	2722	12.8%
1	190	0.9%
0	13	0.1%

bathrooms
Real number (ℝ)

High correlation

Distinct	25
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1007426

Minimum	0
Maximum	6.5
Zeros	10
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	165.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1.5
median	2.25
Q3	2.5
95-th percentile	3.5
Maximum	6.5
Range	6.5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.74420137
Coefficient of variation (CV)	0.35425634
Kurtosis	0.26798102
Mean	2.1007426
Median Absolute Deviation (MAD)	0.5
Skewness	0.29959646
Sum	44556.75
Variance	0.55383567
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
2.5	5332	25.1%
1	3789	17.9%
1.75	3011	14.2%
2.25	2027	9.6%
2	1910	9.0%
1.5	1429	6.7%
2.75	1169	5.5%
3	736	3.5%
3.5	708	3.3%
3.25	564	2.7%
Other values (15)	535	2.5%

Value	Count	Frequency (%)
0	10	< 0.1%
0.5	4	< 0.1%
0.75	67	0.3%
1	3789	17.9%
1.25	9	< 0.1%
1.5	1429	6.7%
1.75	3011	14.2%
2	1910	9.0%
2.25	2027	9.6%
2.5	5332	25.1%

Value	Count	Frequency (%)
6.5	1	< 0.1%
6	2	< 0.1%
5.75	1	< 0.1%
5.5	3	< 0.1%
5.25	9	< 0.1%
5	15	0.1%
4.75	13	0.1%
4.5	78	0.4%
4.25	62	0.3%
4	116	0.5%

sqft_living
Real number (ℝ)

High correlation

Distinct	967
Distinct (%)	4.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2053.7525

Minimum	290
Maximum	7320
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	165.8 KiB

Quantile statistics

Minimum	290
5-th percentile	940
Q1	1420
median	1900
Q3	2530
95-th percentile	3673.1
Maximum	7320
Range	7030
Interquartile range (IQR)	1110

Descriptive statistics

Standard deviation	857.03547
Coefficient of variation (CV)	0.41730222
Kurtosis	1.3481802
Mean	2053.7525
Median Absolute Deviation (MAD)	540
Skewness	0.99409077
Sum	43560090
Variance	734509.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1300	135	0.6%
1440	133	0.6%
1400	132	0.6%
1800	128	0.6%
1660	128	0.6%
1820	127	0.6%
1560	124	0.6%
1010	124	0.6%
1540	122	0.6%
1480	122	0.6%
Other values (957)	19935	94.0%

Value	Count	Frequency (%)
290	1	< 0.1%
370	1	< 0.1%
380	1	< 0.1%
384	1	< 0.1%
390	2	< 0.1%
410	1	< 0.1%
420	2	< 0.1%
430	1	< 0.1%
440	1	< 0.1%
460	1	< 0.1%

Value	Count	Frequency (%)
7320	1	< 0.1%
7080	1	< 0.1%
6810	1	< 0.1%
6640	1	< 0.1%
6563	1	< 0.1%
6500	1	< 0.1%
6430	1	< 0.1%
6380	1	< 0.1%
6370	1	< 0.1%
6330	1	< 0.1%

sqft_lot
Real number (ℝ)

High correlation

Distinct	9638
Distinct (%)	45.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14422.315

Minimum	520
Maximum	1164794
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	165.8 KiB

Quantile statistics

Minimum	520
5-th percentile	1779
Q1	5020.25
median	7570.5
Q3	10522.5
95-th percentile	41807.85
Maximum	1164794
Range	1164274
Interquartile range (IQR)	5502.25

Descriptive statistics

Standard deviation	36749.945
Coefficient of variation (CV)	2.5481308
Kurtosis	217.84818
Mean	14422.315
Median Absolute Deviation (MAD)	2590.5
Skewness	11.582157
Sum	3.058973 × 10⁸
Variance	1.3505584 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	354	1.7%
6000	282	1.3%
4000	248	1.2%
7200	216	1.0%
4800	118	0.6%
7500	117	0.6%
4500	112	0.5%
8400	109	0.5%
9600	108	0.5%
3600	102	0.5%
Other values (9628)	19444	91.7%

Value	Count	Frequency (%)
520	1	< 0.1%
572	1	< 0.1%
600	1	< 0.1%
609	1	< 0.1%
635	1	< 0.1%
638	1	< 0.1%
649	2	< 0.1%
651	1	< 0.1%
675	1	< 0.1%
676	1	< 0.1%

Value	Count	Frequency (%)
1164794	1	< 0.1%
1074218	1	< 0.1%
1024068	1	< 0.1%
982998	1	< 0.1%
982278	1	< 0.1%
843309	1	< 0.1%
715690	1	< 0.1%
641203	1	< 0.1%
623779	1	< 0.1%
577605	1	< 0.1%

floors
Real number (ℝ)

High correlation

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.4926214

Minimum	1
Maximum	3.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	165.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1.5
Q3	2
95-th percentile	2
Maximum	3.5
Range	2.5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.53915024
Coefficient of variation (CV)	0.36121031
Kurtosis	-0.48425389
Mean	1.4926214
Median Absolute Deviation (MAD)	0.5
Skewness	0.61803565
Sum	31658.5
Variance	0.29068298
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	10507	49.5%
2	8083	38.1%
1.5	1871	8.8%
3	599	2.8%
2.5	143	0.7%
3.5	7	< 0.1%

Value	Count	Frequency (%)
1	10507	49.5%
1.5	1871	8.8%
2	8083	38.1%
2.5	143	0.7%
3	599	2.8%
3.5	7	< 0.1%

Value	Count	Frequency (%)
3.5	7	< 0.1%
3	599	2.8%
2.5	143	0.7%
2	8083	38.1%
1.5	1871	8.8%
1	10507	49.5%

waterfront
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	165.8 KiB

0	21134
1	76

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21210
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	21134	99.6%
1	76	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	21134	99.6%
1	76	0.4%

Most occurring characters

Value	Count	Frequency (%)
0	21134	99.6%
1	76	0.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21210	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	21134	99.6%
1	76	0.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21210	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	21134	99.6%
1	76	0.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21210	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	21134	99.6%
1	76	0.4%

view
Categorical

Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	165.8 KiB

0	19273
2	934
3	469
1	327
4	207

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21210
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	19273	90.9%
2	934	4.4%
3	469	2.2%
1	327	1.5%
4	207	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	19273	90.9%
2	934	4.4%
3	469	2.2%
1	327	1.5%
4	207	1.0%

Most occurring characters

Value	Count	Frequency (%)
0	19273	90.9%
2	934	4.4%
3	469	2.2%
1	327	1.5%
4	207	1.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21210	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	19273	90.9%
2	934	4.4%
3	469	2.2%
1	327	1.5%
4	207	1.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21210	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	19273	90.9%
2	934	4.4%
3	469	2.2%
1	327	1.5%
4	207	1.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21210	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	19273	90.9%
2	934	4.4%
3	469	2.2%
1	327	1.5%
4	207	1.0%

condition
Categorical

High correlation

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	165.8 KiB

3	13763
4	5596
5	1661
2	162
1	28

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21210
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	3
3rd row	3
4th row	5
5th row	3

Common Values

Value	Count	Frequency (%)
3	13763	64.9%
4	5596	26.4%
5	1661	7.8%
2	162	0.8%
1	28	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
3	13763	64.9%
4	5596	26.4%
5	1661	7.8%
2	162	0.8%
1	28	0.1%

Most occurring characters

Value	Count	Frequency (%)
3	13763	64.9%
4	5596	26.4%
5	1661	7.8%
2	162	0.8%
1	28	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21210	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
3	13763	64.9%
4	5596	26.4%
5	1661	7.8%
2	162	0.8%
1	28	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21210	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
3	13763	64.9%
4	5596	26.4%
5	1661	7.8%
2	162	0.8%
1	28	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21210	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
3	13763	64.9%
4	5596	26.4%
5	1661	7.8%
2	162	0.8%
1	28	0.1%

grade
Real number (ℝ)

High correlation

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.6365394

Minimum	1
Maximum	13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	165.8 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	7
median	7
Q3	8
95-th percentile	10
Maximum	13
Range	12
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1394594
Coefficient of variation (CV)	0.14921149
Kurtosis	0.99351896
Mean	7.6365394
Median Absolute Deviation (MAD)	1
Skewness	0.68448489
Sum	161971
Variance	1.2983678
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
7	8880	41.9%
8	6022	28.4%
9	2584	12.2%
6	1986	9.4%
10	1086	5.1%
11	331	1.6%
5	232	1.1%
12	52	0.2%
4	29	0.1%
13	4	< 0.1%
Other values (2)	4	< 0.1%

Value	Count	Frequency (%)
1	1	< 0.1%
3	3	< 0.1%
4	29	0.1%
5	232	1.1%
6	1986	9.4%
7	8880	41.9%
8	6022	28.4%
9	2584	12.2%
10	1086	5.1%
11	331	1.6%

Value	Count	Frequency (%)
13	4	< 0.1%
12	52	0.2%
11	331	1.6%
10	1086	5.1%
9	2584	12.2%
8	6022	28.4%
7	8880	41.9%
6	1986	9.4%
5	232	1.1%
4	29	0.1%

sqft_above
Real number (ℝ)

High correlation

Distinct	900
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1770.6566

Minimum	290
Maximum	7320
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	165.8 KiB

Quantile statistics

Minimum	290
5-th percentile	850
Q1	1190
median	1560
Q3	2190
95-th percentile	3320
Maximum	7320
Range	7030
Interquartile range (IQR)	1000

Descriptive statistics

Standard deviation	791.7542
Coefficient of variation (CV)	0.44715287
Kurtosis	1.6482237
Mean	1770.6566
Median Absolute Deviation (MAD)	450
Skewness	1.2112886
Sum	37555627
Variance	626874.71
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1300	209	1.0%
1010	204	1.0%
1200	203	1.0%
1220	186	0.9%
1140	183	0.9%
1400	179	0.8%
1180	176	0.8%
1060	176	0.8%
1340	174	0.8%
1250	173	0.8%
Other values (890)	19347	91.2%

Value	Count	Frequency (%)
290	1	< 0.1%
370	1	< 0.1%
380	1	< 0.1%
384	1	< 0.1%
390	2	< 0.1%
410	1	< 0.1%
420	2	< 0.1%
430	1	< 0.1%
440	1	< 0.1%
460	1	< 0.1%

Value	Count	Frequency (%)
7320	1	< 0.1%
6640	1	< 0.1%
6430	1	< 0.1%
6380	1	< 0.1%
6370	1	< 0.1%
6110	2	< 0.1%
6070	1	< 0.1%
5990	1	< 0.1%
5844	1	< 0.1%
5760	1	< 0.1%

sqft_basement
Real number (ℝ)

High correlation Zeros

Distinct	278
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	283.09585

Minimum	0
Maximum	2850
Zeros	12955
Zeros (%)	61.1%
Negative	0
Negative (%)	0.0%
Memory size	165.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	550
95-th percentile	1160
Maximum	2850
Range	2850
Interquartile range (IQR)	550

Descriptive statistics

Standard deviation	426.5906
Coefficient of variation (CV)	1.5068769
Kurtosis	1.3078512
Mean	283.09585
Median Absolute Deviation (MAD)	0
Skewness	1.4206391
Sum	6004463
Variance	181979.54
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	12955	61.1%
600	217	1.0%
700	214	1.0%
500	210	1.0%
800	205	1.0%
400	184	0.9%
900	143	0.7%
1000	142	0.7%
300	140	0.7%
200	106	0.5%
Other values (268)	6694	31.6%

Value	Count	Frequency (%)
0	12955	61.1%
10	1	< 0.1%
20	1	< 0.1%
40	4	< 0.1%
50	11	0.1%
60	10	< 0.1%
65	1	< 0.1%
70	7	< 0.1%
80	20	0.1%
90	21	0.1%

Value	Count	Frequency (%)
2850	1	< 0.1%
2720	1	< 0.1%
2610	1	< 0.1%
2570	1	< 0.1%
2350	1	< 0.1%
2330	1	< 0.1%
2250	1	< 0.1%
2220	2	< 0.1%
2200	1	< 0.1%
2196	1	< 0.1%

yr_built
Real number (ℝ)

High correlation

Distinct	116
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1971.1416

Minimum	1900
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	165.8 KiB

Quantile statistics

Minimum	1900
5-th percentile	1915
Q1	1952
median	1975
Q3	1997
95-th percentile	2011
Maximum	2015
Range	115
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	29.317482
Coefficient of variation (CV)	0.014873351
Kurtosis	-0.64602845
Mean	1971.1416
Median Absolute Deviation (MAD)	23
Skewness	-0.47422058
Sum	41807913
Variance	859.51473
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2014	557	2.6%
2006	450	2.1%
2005	445	2.1%
2004	424	2.0%
2003	419	2.0%
1977	414	2.0%
2007	409	1.9%
1978	381	1.8%
1968	378	1.8%
2008	362	1.7%
Other values (106)	16971	80.0%

Value	Count	Frequency (%)
1900	86	0.4%
1901	29	0.1%
1902	27	0.1%
1903	43	0.2%
1904	43	0.2%
1905	73	0.3%
1906	89	0.4%
1907	63	0.3%
1908	85	0.4%
1909	91	0.4%

Value	Count	Frequency (%)
2015	38	0.2%
2014	557	2.6%
2013	198	0.9%
2012	169	0.8%
2011	130	0.6%
2010	141	0.7%
2009	225	1.1%
2008	362	1.7%
2007	409	1.9%
2006	450	2.1%

yr_renovated
Real number (ℝ)

Zeros

Distinct	70
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	79.146865

Minimum	0
Maximum	2015
Zeros	20369
Zeros (%)	96.0%
Negative	0
Negative (%)	0.0%
Memory size	165.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	2015
Range	2015
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	389.53362
Coefficient of variation (CV)	4.9216557
Kurtosis	20.272701
Mean	79.146865
Median Absolute Deviation (MAD)	0
Skewness	4.7190157
Sum	1678705
Variance	151736.44
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	20369	96.0%
2014	91	0.4%
2013	36	0.2%
2005	35	0.2%
2007	35	0.2%
2000	33	0.2%
2003	31	0.1%
2004	26	0.1%
2006	21	0.1%
1989	20	0.1%
Other values (60)	513	2.4%

Value	Count	Frequency (%)
0	20369	96.0%
1934	1	< 0.1%
1940	2	< 0.1%
1944	1	< 0.1%
1945	3	< 0.1%
1946	2	< 0.1%
1948	1	< 0.1%
1950	2	< 0.1%
1951	1	< 0.1%
1953	3	< 0.1%

Value	Count	Frequency (%)
2015	14	0.1%
2014	91	0.4%
2013	36	0.2%
2012	11	0.1%
2011	13	0.1%
2010	17	0.1%
2009	20	0.1%
2008	16	0.1%
2007	35	0.2%
2006	21	0.1%

zipcode
Real number (ℝ)

High correlation

Distinct	70
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	98077.883

Minimum	98001
Maximum	98199
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	165.8 KiB

Quantile statistics

Minimum	98001
5-th percentile	98004
Q1	98033
median	98065
Q3	98117
95-th percentile	98177
Maximum	98199
Range	198
Interquartile range (IQR)	84

Descriptive statistics

Standard deviation	53.360672
Coefficient of variation (CV)	0.00054406427
Kurtosis	-0.84862513
Mean	98077.883
Median Absolute Deviation (MAD)	42
Skewness	0.40528652
Sum	2.0802319 × 10⁹
Variance	2847.3613
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
98103	598	2.8%
98038	585	2.8%
98115	575	2.7%
98052	570	2.7%
98117	548	2.6%
98042	546	2.6%
98034	539	2.5%
98118	497	2.3%
98023	489	2.3%
98133	485	2.3%
Other values (60)	15778	74.4%

Value	Count	Frequency (%)
98001	359	1.7%
98002	197	0.9%
98003	276	1.3%
98004	301	1.4%
98005	168	0.8%
98006	471	2.2%
98007	139	0.7%
98008	276	1.3%
98010	98	0.5%
98011	194	0.9%

Value	Count	Frequency (%)
98199	309	1.5%
98198	269	1.3%
98188	135	0.6%
98178	257	1.2%
98177	239	1.1%
98168	264	1.2%
98166	242	1.1%
98155	438	2.1%
98148	56	0.3%
98146	279	1.3%

lat
Real number (ℝ)

High correlation

Distinct	5023
Distinct (%)	23.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47.560012

Minimum	47.1559
Maximum	47.7776
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	165.8 KiB

Quantile statistics

Minimum	47.1559
5-th percentile	47.3103
Q1	47.470325
median	47.5719
Q3	47.6782
95-th percentile	47.7496
Maximum	47.7776
Range	0.6217
Interquartile range (IQR)	0.207875

Descriptive statistics

Standard deviation	0.13875891
Coefficient of variation (CV)	0.0029175541
Kurtosis	-0.68311691
Mean	47.560012
Median Absolute Deviation (MAD)	0.105
Skewness	-0.48474394
Sum	1008747.9
Variance	0.019254034
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
47.5322	17	0.1%
47.5491	17	0.1%
47.6624	17	0.1%
47.6846	17	0.1%
47.6886	16	0.1%
47.6955	16	0.1%
47.6711	16	0.1%
47.686	15	0.1%
47.5402	15	0.1%
47.6647	15	0.1%
Other values (5013)	21049	99.2%

Value	Count	Frequency (%)
47.1559	1	< 0.1%
47.1593	1	< 0.1%
47.1622	1	< 0.1%
47.1647	1	< 0.1%
47.1764	1	< 0.1%
47.1775	1	< 0.1%
47.1776	2	< 0.1%
47.1795	1	< 0.1%
47.1803	1	< 0.1%
47.1808	1	< 0.1%

Value	Count	Frequency (%)
47.7776	3	< 0.1%
47.7775	3	< 0.1%
47.7774	1	< 0.1%
47.7772	3	< 0.1%
47.7771	2	< 0.1%
47.777	2	< 0.1%
47.7769	3	< 0.1%
47.7768	2	< 0.1%
47.7767	6	< 0.1%
47.7766	4	< 0.1%

long
Real number (ℝ)

High correlation

Distinct	747
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-122.2138

Minimum	-122.519
Maximum	-121.315
Zeros	0
Zeros (%)	0.0%
Negative	21210
Negative (%)	100.0%
Memory size	165.8 KiB

Quantile statistics

Minimum	-122.519
5-th percentile	-122.387
Q1	-122.328
median	-122.23
Q3	-122.125
95-th percentile	-121.98
Maximum	-121.315
Range	1.204
Interquartile range (IQR)	0.203

Descriptive statistics

Standard deviation	0.14055389
Coefficient of variation (CV)	-0.0011500656
Kurtosis	1.0355209
Mean	-122.2138
Median Absolute Deviation (MAD)	0.101
Skewness	0.88005048
Sum	-2592154.7
Variance	0.019755395
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-122.29	114	0.5%
-122.3	110	0.5%
-122.291	99	0.5%
-122.363	98	0.5%
-122.362	98	0.5%
-122.357	95	0.4%
-122.372	95	0.4%
-122.288	95	0.4%
-122.346	93	0.4%
-122.365	93	0.4%
Other values (737)	20220	95.3%

Value	Count	Frequency (%)
-122.519	1	< 0.1%
-122.515	1	< 0.1%
-122.514	1	< 0.1%
-122.512	1	< 0.1%
-122.511	1	< 0.1%
-122.509	2	< 0.1%
-122.507	1	< 0.1%
-122.506	1	< 0.1%
-122.505	3	< 0.1%
-122.504	2	< 0.1%

Value	Count	Frequency (%)
-121.315	2	< 0.1%
-121.316	1	< 0.1%
-121.319	1	< 0.1%
-121.321	1	< 0.1%
-121.325	1	< 0.1%
-121.352	2	< 0.1%
-121.359	1	< 0.1%
-121.364	2	< 0.1%
-121.402	1	< 0.1%
-121.403	1	< 0.1%

sqft_living15
Real number (ℝ)

High correlation

Distinct	757
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1974.7783

Minimum	399
Maximum	5790
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	165.8 KiB

Quantile statistics

Minimum	399
5-th percentile	1140
Q1	1480
median	1830
Q3	2350
95-th percentile	3240
Maximum	5790
Range	5391
Interquartile range (IQR)	870

Descriptive statistics

Standard deviation	668.18396
Coefficient of variation (CV)	0.33835898
Kurtosis	1.3194834
Mean	1974.7783
Median Absolute Deviation (MAD)	410
Skewness	1.0440776
Sum	41885047
Variance	446469.81
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1540	193	0.9%
1440	190	0.9%
1560	190	0.9%
1500	179	0.8%
1460	167	0.8%
1800	165	0.8%
1580	165	0.8%
1720	165	0.8%
1610	164	0.8%
1620	163	0.8%
Other values (747)	19469	91.8%

Value	Count	Frequency (%)
399	1	< 0.1%
460	2	< 0.1%
620	2	< 0.1%
670	1	< 0.1%
690	2	< 0.1%
700	2	< 0.1%
710	2	< 0.1%
720	2	< 0.1%
740	8	< 0.1%
750	3	< 0.1%

Value	Count	Frequency (%)
5790	5	< 0.1%
5600	1	< 0.1%
5330	1	< 0.1%
5200	1	< 0.1%
5170	1	< 0.1%
5110	1	< 0.1%
5080	1	< 0.1%
5030	1	< 0.1%
5000	1	< 0.1%
4950	1	< 0.1%

sqft_lot15
Real number (ℝ)

High correlation

Distinct	8561
Distinct (%)	40.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12303.153

Minimum	651
Maximum	560617
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	165.8 KiB

Quantile statistics

Minimum	651
5-th percentile	1971.15
Q1	5099.25
median	7600
Q3	10012.75
95-th percentile	36444
Maximum	560617
Range	559966
Interquartile range (IQR)	4913.5

Descriptive statistics

Standard deviation	24568.618
Coefficient of variation (CV)	1.9969368
Kurtosis	79.687615
Mean	12303.153
Median Absolute Deviation (MAD)	2492
Skewness	7.8191253
Sum	2.6094986 × 10⁸
Variance	6.0361697 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	424	2.0%
4000	354	1.7%
6000	284	1.3%
7200	207	1.0%
4800	144	0.7%
7500	142	0.7%
8400	115	0.5%
4500	110	0.5%
3600	110	0.5%
5100	109	0.5%
Other values (8551)	19211	90.6%

Value	Count	Frequency (%)
651	1	< 0.1%
659	1	< 0.1%
660	1	< 0.1%
748	2	< 0.1%
750	4	< 0.1%
755	1	< 0.1%
757	1	< 0.1%
758	1	< 0.1%
788	1	< 0.1%
794	1	< 0.1%

Value	Count	Frequency (%)
560617	1	< 0.1%
438213	1	< 0.1%
434728	1	< 0.1%
392040	2	< 0.1%
380279	1	< 0.1%
360000	1	< 0.1%
358934	1	< 0.1%
339332	1	< 0.1%
335289	1	< 0.1%
326097	1	< 0.1%

year
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	165.8 KiB

2014	14313
2015	6897

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	84840
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2014
2nd row	2014
3rd row	2015
4th row	2014
5th row	2015

Common Values

Value	Count	Frequency (%)
2014	14313	67.5%
2015	6897	32.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2014	14313	67.5%
2015	6897	32.5%

Most occurring characters

Value	Count	Frequency (%)
2	21210	25.0%
0	21210	25.0%
1	21210	25.0%
4	14313	16.9%
5	6897	8.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	84840	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	21210	25.0%
0	21210	25.0%
1	21210	25.0%
4	14313	16.9%
5	6897	8.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	84840	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	21210	25.0%
0	21210	25.0%
1	21210	25.0%
4	14313	16.9%
5	6897	8.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	84840	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	21210	25.0%
0	21210	25.0%
1	21210	25.0%
4	14313	16.9%
5	6897	8.1%

age
Real number (ℝ)

High correlation Zeros

Distinct	116
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.932579

Minimum	0
Maximum	115
Zeros	530
Zeros (%)	2.5%
Negative	0
Negative (%)	0.0%
Memory size	165.8 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	15
median	37
Q3	60
95-th percentile	97
Maximum	115
Range	115
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	28.79275
Coefficient of variation (CV)	0.70341892
Kurtosis	-0.52778385
Mean	40.932579
Median Absolute Deviation (MAD)	22
Skewness	0.55321183
Sum	868180
Variance	829.02247
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	530	2.5%
9	493	2.3%
8	470	2.2%
11	459	2.2%
10	451	2.1%
7	419	2.0%
37	384	1.8%
36	378	1.8%
47	346	1.6%
6	336	1.6%
Other values (106)	16944	79.9%

Value	Count	Frequency (%)
0	530	2.5%
1	328	1.5%
2	187	0.9%
3	178	0.8%
4	130	0.6%
5	220	1.0%
6	336	1.6%
7	419	2.0%
8	470	2.2%
9	493	2.3%

Value	Count	Frequency (%)
115	21	0.1%
114	53	0.2%
113	27	0.1%
112	31	0.1%
111	40	0.2%
110	43	0.2%
109	58	0.3%
108	70	0.3%
107	67	0.3%
106	62	0.3%

Interactions

Correlations

	id	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	waterfront	view	condition	grade	sqft_above	sqft_basement	yr_built	yr_renovated	zipcode	lat	long	sqft_living15	sqft_lot15	year	age
id	1.000	-0.017	0.003	0.009	-0.009	-0.136	0.019	0.002	0.019	-0.024	0.011	-0.008	-0.003	0.022	-0.016	-0.009	-0.003	0.021	-0.001	-0.143	0.011	-0.018
price	-0.017	1.000	0.315	0.503	0.675	0.069	0.263	0.108	0.324	0.038	0.670	0.583	0.274	0.058	0.100	-0.052	0.344	0.023	0.589	0.060	0.004	-0.101
bedrooms	0.003	0.315	1.000	0.521	0.599	0.025	0.173	-0.029	0.066	0.026	0.360	0.488	0.297	0.166	0.012	-0.162	-0.018	0.137	0.400	0.022	-0.009	-0.174
bathrooms	0.009	0.503	0.521	1.000	0.740	0.066	0.503	0.004	0.143	-0.132	0.651	0.667	0.249	0.522	0.037	-0.208	0.018	0.227	0.556	0.060	-0.028	-0.549
sqft_living	-0.009	0.675	0.599	0.740	1.000	0.152	0.354	0.012	0.226	-0.064	0.752	0.869	0.396	0.336	0.034	-0.209	0.046	0.250	0.756	0.155	-0.031	-0.355
sqft_lot	-0.136	0.069	0.025	0.066	0.152	1.000	-0.016	0.019	0.046	-0.009	0.096	0.166	-0.004	0.055	0.001	-0.134	-0.087	0.230	0.138	0.695	-0.004	-0.052
floors	0.019	0.263	0.173	0.503	0.354	-0.016	1.000	0.003	0.011	-0.271	0.457	0.527	-0.267	0.496	0.001	-0.060	0.047	0.126	0.276	-0.023	-0.024	-0.510
waterfront	0.002	0.108	-0.029	0.004	0.012	0.019	0.003	1.000	0.292	0.017	0.018	0.003	0.018	-0.021	0.016	0.037	-0.019	-0.037	0.028	0.020	0.002	0.019
view	0.019	0.324	0.066	0.143	0.226	0.046	0.011	0.292	1.000	0.046	0.206	0.113	0.244	-0.056	0.060	0.091	0.004	-0.082	0.245	0.045	0.001	0.036
condition	-0.024	0.038	0.026	-0.132	-0.064	-0.009	-0.271	0.017	0.046	1.000	-0.154	-0.168	0.184	-0.365	-0.061	0.003	-0.016	-0.106	-0.098	-0.000	-0.046	0.398
grade	0.011	0.670	0.360	0.651	0.752	0.096	0.457	0.018	0.206	-0.154	1.000	0.746	0.126	0.458	-0.003	-0.189	0.111	0.200	0.703	0.099	-0.034	-0.467
sqft_above	-0.008	0.583	0.488	0.667	0.869	0.166	0.527	0.003	0.113	-0.168	0.746	1.000	-0.110	0.441	0.007	-0.272	-0.009	0.356	0.730	0.171	-0.027	-0.448
sqft_basement	-0.003	0.274	0.297	0.249	0.396	-0.004	-0.267	0.018	0.244	0.184	0.126	-0.110	1.000	-0.144	0.055	0.084	0.108	-0.157	0.164	-0.007	-0.012	0.119
yr_built	0.022	0.058	0.166	0.522	0.336	0.055	0.496	-0.021	-0.056	-0.365	0.458	0.441	-0.144	1.000	-0.220	-0.346	-0.151	0.408	0.333	0.072	0.002	-0.913
yr_renovated	-0.016	0.100	0.012	0.037	0.034	0.001	0.001	0.016	0.060	-0.061	-0.003	0.007	0.055	-0.220	1.000	0.064	0.030	-0.065	-0.022	-0.000	-0.026	-0.161
zipcode	-0.009	-0.052	-0.162	-0.208	-0.209	-0.134	-0.060	0.037	0.091	0.003	-0.189	-0.272	0.084	-0.346	0.064	1.000	0.268	-0.564	-0.283	-0.153	0.004	0.320
lat	-0.003	0.344	-0.018	0.018	0.046	-0.087	0.047	-0.019	0.004	-0.016	0.111	-0.009	0.108	-0.151	0.030	0.268	1.000	-0.137	0.045	-0.088	-0.030	0.138
long	0.021	0.023	0.137	0.227	0.250	0.230	0.126	-0.037	-0.082	-0.106	0.200	0.356	-0.157	0.408	-0.065	-0.564	-0.137	1.000	0.340	0.257	-0.002	-0.383
sqft_living15	-0.001	0.589	0.400	0.556	0.756	0.138	0.276	0.028	0.245	-0.098	0.703	0.730	0.164	0.333	-0.022	-0.283	0.045	0.340	1.000	0.175	-0.024	-0.325
sqft_lot15	-0.143	0.060	0.022	0.060	0.155	0.695	-0.023	0.020	0.045	-0.000	0.099	0.171	-0.007	0.072	-0.000	-0.153	-0.088	0.257	0.175	1.000	-0.008	-0.068
year	0.011	0.004	-0.009	-0.028	-0.031	-0.004	-0.024	0.002	0.001	-0.046	-0.034	-0.027	-0.012	0.002	-0.026	0.004	-0.030	-0.002	-0.024	-0.008	1.000	0.025
age	-0.018	-0.101	-0.174	-0.549	-0.355	-0.052	-0.510	0.019	0.036	0.398	-0.467	-0.448	0.119	-0.913	-0.161	0.320	0.138	-0.383	-0.325	-0.068	0.025	1.000

	id	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	waterfront	view	condition	grade	sqft_above	sqft_basement	yr_built	yr_renovated	zipcode	lat	long	sqft_living15	sqft_lot15	year	age
id	1.000	0.081	0.041	0.073	0.079	0.121	0.081	0.017	0.069	0.071	0.112	0.091	0.084	0.162	0.034	0.350	0.268	0.326	0.116	0.105	0.011	0.153
price	0.081	1.000	0.249	0.584	0.697	0.000	0.243	0.161	0.387	0.101	0.668	0.657	0.320	0.191	0.129	0.312	0.519	0.238	0.573	0.000	0.000	0.211
bedrooms	0.041	0.249	1.000	0.558	0.521	0.000	0.279	0.028	0.065	0.091	0.416	0.452	0.282	0.277	0.025	0.221	0.137	0.202	0.345	0.000	0.009	0.281
bathrooms	0.073	0.584	0.558	1.000	0.762	0.003	0.447	0.000	0.208	0.270	0.695	0.689	0.366	0.575	0.092	0.318	0.250	0.304	0.570	0.026	0.037	0.584
sqft_living	0.079	0.697	0.521	0.762	1.000	0.097	0.379	0.038	0.275	0.172	0.761	0.957	0.587	0.422	0.054	0.339	0.231	0.323	0.766	0.078	0.033	0.438
sqft_lot	0.121	0.000	0.000	0.003	0.097	1.000	0.030	0.044	0.063	0.072	0.083	0.126	0.055	0.087	0.000	0.128	0.180	0.231	0.076	0.570	0.000	0.092
floors	0.081	0.243	0.279	0.447	0.379	0.030	1.000	0.025	0.023	0.262	0.368	0.505	0.247	0.622	0.075	0.340	0.250	0.306	0.335	0.053	0.032	0.612
waterfront	0.017	0.161	0.028	0.000	0.038	0.044	0.025	1.000	0.380	0.020	0.030	0.018	0.022	0.036	0.019	0.102	0.054	0.117	0.054	0.000	0.000	0.034
view	0.069	0.387	0.065	0.208	0.275	0.063	0.023	0.380	1.000	0.065	0.240	0.148	0.310	0.106	0.053	0.170	0.156	0.194	0.298	0.055	0.000	0.079
condition	0.071	0.101	0.091	0.270	0.172	0.072	0.262	0.020	0.065	1.000	0.349	0.259	0.231	0.532	0.056	0.177	0.138	0.191	0.151	0.014	0.042	0.554
grade	0.112	0.668	0.416	0.695	0.761	0.083	0.368	0.030	0.240	0.349	1.000	0.757	0.253	0.498	0.029	0.327	0.327	0.298	0.731	0.054	0.037	0.504
sqft_above	0.091	0.657	0.452	0.689	0.957	0.126	0.505	0.018	0.148	0.259	0.757	1.000	0.283	0.536	0.052	0.427	0.230	0.402	0.748	0.094	0.030	0.541
sqft_basement	0.084	0.320	0.282	0.366	0.587	0.055	0.247	0.022	0.310	0.231	0.253	0.283	1.000	0.313	0.078	0.234	0.171	0.230	0.307	0.000	0.020	0.283
yr_built	0.162	0.191	0.277	0.575	0.422	0.087	0.622	0.036	0.106	0.532	0.498	0.536	0.313	1.000	0.297	0.622	0.446	0.542	0.407	0.072	0.020	0.997
yr_renovated	0.034	0.129	0.025	0.092	0.054	0.000	0.075	0.019	0.053	0.056	0.029	0.052	0.078	0.297	1.000	0.115	0.077	0.098	0.017	0.000	0.038	0.221
zipcode	0.350	0.312	0.221	0.318	0.339	0.128	0.340	0.102	0.170	0.177	0.327	0.427	0.234	0.622	0.115	1.000	0.794	0.786	0.451	0.131	0.016	0.606
lat	0.268	0.519	0.137	0.250	0.231	0.180	0.250	0.054	0.156	0.138	0.327	0.230	0.171	0.446	0.077	0.794	1.000	0.492	0.286	0.135	0.044	0.438
long	0.326	0.238	0.202	0.304	0.323	0.231	0.306	0.117	0.194	0.191	0.298	0.402	0.230	0.542	0.098	0.786	0.492	1.000	0.433	0.212	0.025	0.527
sqft_living15	0.116	0.573	0.345	0.570	0.766	0.076	0.335	0.054	0.298	0.151	0.731	0.748	0.307	0.407	0.017	0.451	0.286	0.433	1.000	0.087	0.022	0.402
sqft_lot15	0.105	0.000	0.000	0.026	0.078	0.570	0.053	0.000	0.055	0.014	0.054	0.094	0.000	0.072	0.000	0.131	0.135	0.212	0.087	1.000	0.000	0.073
year	0.011	0.000	0.009	0.037	0.033	0.000	0.032	0.000	0.000	0.042	0.037	0.030	0.020	0.020	0.038	0.016	0.044	0.025	0.022	0.000	1.000	0.051
age	0.153	0.211	0.281	0.584	0.438	0.092	0.612	0.034	0.079	0.554	0.504	0.541	0.283	0.997	0.221	0.606	0.438	0.527	0.402	0.073	0.051	1.000

	age	bathrooms	bedrooms	condition	floors	grade	id	lat	long	price	sqft_above	sqft_basement	sqft_living	sqft_living15	sqft_lot	sqft_lot15	view	waterfront	year	yr_built	yr_renovated	zipcode
age	1.000	-0.595	-0.187	0.262	-0.579	-0.512	-0.023	0.113	-0.371	-0.144	-0.485	0.159	-0.372	-0.326	0.073	0.052	0.033	0.026	0.039	-0.916	-0.173	0.277
bathrooms	-0.595	1.000	0.517	0.115	0.545	0.651	0.017	0.004	0.263	0.484	0.684	0.179	0.740	0.563	0.055	0.051	0.088	0.000	0.028	0.574	0.032	-0.205
bedrooms	-0.187	0.517	1.000	0.052	0.222	0.375	0.007	-0.027	0.192	0.337	0.536	0.222	0.646	0.441	0.213	0.199	0.038	0.028	0.009	0.181	0.012	-0.168
condition	0.262	0.115	0.052	1.000	0.181	0.156	0.030	0.058	0.081	0.042	0.110	0.098	0.072	0.063	0.030	0.008	0.024	0.025	0.051	0.249	0.069	0.074
floors	-0.579	0.545	0.222	0.181	1.000	0.499	0.019	0.022	0.150	0.315	0.597	-0.284	0.396	0.301	-0.245	-0.241	0.015	0.018	0.023	0.559	0.007	-0.062
grade	-0.512	0.651	0.375	0.156	0.499	1.000	0.021	0.100	0.223	0.649	0.706	0.077	0.710	0.656	0.139	0.144	0.110	0.026	0.028	0.504	0.003	-0.181
id	-0.023	0.017	0.007	0.030	0.019	0.021	1.000	-0.005	0.008	0.005	0.005	0.002	0.003	0.001	-0.115	-0.114	0.029	0.013	0.008	0.027	-0.016	-0.006
lat	0.113	0.004	-0.027	0.058	0.022	0.100	-0.005	1.000	-0.144	0.461	-0.031	0.114	0.026	0.024	-0.123	-0.117	0.065	0.041	0.033	-0.128	0.026	0.250
long	-0.371	0.263	0.192	0.081	0.150	0.223	0.008	-0.144	1.000	0.061	0.389	-0.206	0.287	0.384	0.374	0.375	0.082	0.090	0.019	0.410	-0.071	-0.576
price	-0.144	0.484	0.337	0.042	0.315	0.649	0.005	0.461	0.061	1.000	0.530	0.240	0.635	0.562	0.059	0.048	0.171	0.123	0.000	0.098	0.088	-0.004
sqft_above	-0.485	0.684	0.536	0.110	0.597	0.706	0.005	-0.031	0.389	0.530	1.000	-0.186	0.840	0.693	0.263	0.246	0.062	0.014	0.023	0.477	0.019	-0.281
sqft_basement	0.159	0.179	0.222	0.098	-0.284	0.077	0.002	0.114	-0.206	0.240	-0.186	1.000	0.316	0.115	0.026	0.020	0.134	0.017	0.015	-0.183	0.052	0.119
sqft_living	-0.372	0.740	0.646	0.072	0.396	0.710	0.003	0.026	0.287	0.635	0.840	0.316	1.000	0.743	0.294	0.275	0.117	0.029	0.026	0.356	0.038	-0.208
sqft_living15	-0.326	0.563	0.441	0.063	0.301	0.656	0.001	0.024	0.384	0.562	0.693	0.115	0.743	1.000	0.351	0.358	0.128	0.042	0.017	0.338	-0.021	-0.289
sqft_lot	0.073	0.055	0.213	0.030	-0.245	0.139	-0.115	-0.123	0.374	0.059	0.263	0.026	0.294	0.351	1.000	0.922	0.026	0.034	0.000	-0.041	-0.005	-0.322
sqft_lot15	0.052	0.051	0.199	0.008	-0.241	0.144	-0.114	-0.117	0.375	0.048	0.246	0.020	0.275	0.358	0.922	1.000	0.031	0.000	0.000	-0.020	-0.004	-0.328
view	0.033	0.088	0.038	0.024	0.015	0.110	0.029	0.065	0.082	0.171	0.062	0.134	0.117	0.128	0.026	0.031	1.000	0.463	0.000	0.044	0.065	0.071
waterfront	0.026	0.000	0.028	0.025	0.018	0.026	0.013	0.041	0.090	0.123	0.014	0.017	0.029	0.042	0.034	0.000	0.463	1.000	0.000	0.029	0.012	0.078
year	0.039	0.028	0.009	0.051	0.023	0.028	0.008	0.033	0.019	0.000	0.023	0.015	0.026	0.017	0.000	0.000	0.000	0.000	1.000	0.015	0.024	0.012
yr_built	-0.916	0.574	0.181	0.249	0.559	0.504	0.027	-0.128	0.410	0.098	0.477	-0.183	0.356	0.338	-0.041	-0.020	0.044	0.029	0.015	1.000	-0.210	-0.315
yr_renovated	-0.173	0.032	0.012	0.069	0.007	0.003	-0.016	0.026	-0.071	0.088	0.019	0.052	0.038	-0.021	-0.005	-0.004	0.065	0.012	0.024	-0.210	1.000	0.064
zipcode	0.277	-0.205	-0.168	0.074	-0.062	-0.181	-0.006	0.250	-0.576	-0.004	-0.281	0.119	-0.208	-0.289	-0.322	-0.328	0.071	0.078	0.012	-0.315	0.064	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	id	date	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	condition	grade	sqft_above	sqft_basement	yr_built	yr_renovated	zipcode	lat	long	sqft_living15	sqft_lot15	year	age
0	7129300520	2014-10-13	221900.0	3	1.00	1180	5650	1.0	3	7	1180	0	1955	0	98178	47.5112	-122.257	1340	5650	2014	59
1	6414100192	2014-12-09	538000.0	3	2.25	2570	7242	2.0	3	7	2170	400	1951	1991	98125	47.7210	-122.319	1690	7639	2014	23
2	5631500400	2015-02-25	180000.0	2	1.00	770	10000	1.0	3	6	770	0	1933	0	98028	47.7379	-122.233	2720	8062	2015	82
3	2487200875	2014-12-09	604000.0	4	3.00	1960	5000	1.0	5	7	1050	910	1965	0	98136	47.5208	-122.393	1360	5000	2014	49
4	1954400510	2015-02-18	510000.0	3	2.00	1680	8080	1.0	3	8	1680	0	1987	0	98074	47.6168	-122.045	1800	7503	2015	28
5	1321400060	2014-06-27	257500.0	3	2.25	1715	6819	2.0	3	7	1715	0	1995	0	98003	47.3097	-122.327	2238	6819	2014	19
6	2008000270	2015-01-15	291850.0	3	1.50	1060	9711	1.0	3	7	1060	0	1963	0	98198	47.4095	-122.315	1650	9711	2015	52
7	2414600126	2015-04-15	229500.0	3	1.00	1780	7470	1.0	3	7	1050	730	1960	0	98146	47.5123	-122.337	1780	8113	2015	55
8	3793500160	2015-03-12	323000.0	3	2.50	1890	6560	2.0	3	7	1890	0	2003	0	98038	47.3684	-122.031	2390	7570	2015	12
9	1736800520	2015-04-03	662500.0	3	2.50	3560	9796	1.0	3	8	1860	1700	1965	0	98007	47.6007	-122.145	2210	8925	2015	50

	id	date	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	condition	grade	sqft_above	sqft_basement	yr_built	zipcode	lat	long	sqft_living15	sqft_lot15	year	age
21200	7852140040	2014-08-25	507250.0	3	2.50	2270	5536	2.0	3	8	2270	0	2003	98065	47.5389	-121.881	2270	5731	2014	11
21201	9834201367	2015-01-26	429000.0	3	2.00	1490	1126	3.0	3	8	1490	0	2014	98144	47.5699	-122.288	1400	1230	2015	1
21202	3448900210	2014-10-14	610685.0	4	2.50	2520	6023	2.0	3	9	2520	0	2014	98056	47.5137	-122.167	2520	6023	2014	0
21203	7936000429	2015-03-26	1007500.0	4	3.50	3510	7200	2.0	3	9	2600	910	2009	98136	47.5537	-122.398	2050	6200	2015	6
21204	2997800021	2015-02-19	475000.0	3	2.50	1310	1294	2.0	3	8	1180	130	2008	98116	47.5773	-122.409	1330	1265	2015	7
21205	263000018	2014-05-21	360000.0	3	2.50	1530	1131	3.0	3	8	1530	0	2009	98103	47.6993	-122.346	1530	1509	2014	5
21206	6600060120	2015-02-23	400000.0	4	2.50	2310	5813	2.0	3	8	2310	0	2014	98146	47.5107	-122.362	1830	7200	2015	1
21207	1523300141	2014-06-23	402101.0	2	0.75	1020	1350	2.0	3	7	1020	0	2009	98144	47.5944	-122.299	1020	2007	2014	5
21208	291310100	2015-01-16	400000.0	3	2.50	1600	2388	2.0	3	8	1600	0	2004	98027	47.5345	-122.069	1410	1287	2015	11
21209	1523300157	2014-10-15	325000.0	2	0.75	1020	1076	2.0	3	7	1020	0	2008	98144	47.5941	-122.299	1020	1357	2014	6

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample